Nic Larsen ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	41

About Me

About Me

Not much happening here, yet.

Analytics

526

Posts

2,457

Visits

11.4k

Points

Jun 26, 2018

Join Date

10:16 pm

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 57

  57

• Discussions2
• Comments524

• Re: COUNTIF using IFERROR and MONTHs

  Nic Larsen

  11/02/20
  You bet. Let me see. 1) You first picked your range and then you need the criteria. In this case you have multiple criteria so you start with OR, followed by the IFERROR in case there was a data erro…
  1 ·

• Re: Another question about nested IF statements!

  Nic Larsen

  10/29/20
  Sure thing: =IF(ISBLANK([Start Date]@row), "Not Started", IF(AND([% Complete]@row <> 1, [End Date]@row < TODAY()), "Overdue", IF([% Complete]@row = 1, "Complete"…
  1 ·

• Re: Another question about nested IF statements!

  Nic Larsen

  10/29/20
  Try this =IF(AND([% Complete]@row <> 1, [End Date]@row < TODAY()), "Overdue", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "…
  1 ·

• Re: Countif not containing specific text

  Nic Larsen

  04/02/19
  Try this: =COUNTIFS([Aging]:[Aging], "Red", Project:Project, NOT(FIND("spring", LOWER(@cell)) >0))
  2 ·

Previous